package togetherOne.dao;

import java.util.ArrayList;


import togetherOne.vo.MemberVo;

public interface MemberDao {
	public void insertMember (MemberVo mem);
	public ArrayList<MemberVo> getMember(MemberVo mem);
	public void updateMemberByEmail(MemberVo mem);
	public void deleteMemberByEmail(String email);
}


/*
	<insert id="insertMember" parameterClass="mem">
		insert into member values(m1.nextval,#memEmail#,#memName#,#memPassword#,#memPhone#)
	</insert>
	
	<select id="getMember" parameterClass = "mem">
		select * from member where mem_email = #memEmail# and mem_password = #memPassword#
	</select>

	<update id="updateMemberByEmail" parameterClass="mem">
		update member set mem_password= #memPassword# , mem_phone = #memPhone# where mem_email = #memEmail#
	</update>
	
	<delete id="deleteMemberByEmail" parameterClass="String">
		delete from member where mem_email = #memEmail#
	</delete>
*/